select * from (SELECT ft.FuelTypeCode,a.driver_type,a.gvwr,a.Cylinders,a.ProductID,a.SSPartNo,a.CoreCharge,d.Description as modelname,b.ModelID,b.SubModelID,b.MakeID,e.Description as enginetype,a.Price,a.ImageFileName,a.SizeLiters,a.SizeCID,b.StartYear,b.EndYear,b.ProductDetailID,c.SubModelCode,f.Description as makename,o.id as oilId,a.transmission,a.trimname,a.notes,a.drivesysytem,a.HDCast FROM products a LEFT JOIN productdetail b ON a.ProductID=b.ProductID LEFT JOIN submodels c ON b.SubModelID=c.SubModelID LEFT Join models d ON d.ModelID = b.ModelID LEFT Join enginetypes e ON a.EngineTypeID = e.EngineTypeID LEFT Join makes f ON f.MakeID = b.MakeID LEFT JOIN oilmanange o ON a.oilId = o.id left join fueltypes ft on  ft.FuelTypeID=a.FuelTypeID WHERE a.status ="0" AND SSPartNo LIKE "%GMC-327MLB-R%" group by a.ProductID order by a.SizeLiters ASC) x